Spring 2022 Course Syllabus
Course: ITSE-1346- Section: 01
Database Theory and Design
LSCPA Logo Image
Instructor Information
Instructor Sarita Medhekar
E-mailmedhekarsv@lamarpa.edu
Phone(409) 984-6390
Office
Location:Madison Monroe Education - Room: 114
Hours:M-W 9-10 am and 12-3 pm, TU-TH 9-9:30 am, F 9-10 am.
COVID 19 Information The Lamar State College Port Arthur (LSCPA) Student Code of Conduct COVID 19 Policy requires students who have been exposed to COVID 19 or diagnosed with COVID 19 to report their condition on the COVID 19 Notification Form (available via a link on the Student Code of Conduct COVID19 webpage). This information will be provided to the Dean of Student Services. In addition, this policy requires all students to wear face coverings in compliance with the criteria included in the policy. For more information please refer to the COVID 19 link on the LSCPA website.
Course Information
Description Introduction to the analysis and utilization of data requirements and organization into normalized tables using the normal forms of database design.
Prerequisites None
Learning Outcomes Alpha. Demonstrates comprehension of content-area reading material (PSLO Alpha) measured by pre-test/post-test.
1. Develop an understanding of database theory and the practical applications of a database. (PSLO 1); measured by quiz.
2. Create and modify Cross-tab Queries, Parameter Queries and Sub Queries. (PSLO 2); measured by end of chapter Assessment assignment.
3. Structure a database. (PSLO 3); measured by end of chapter Assessment assignment.
4. Create and format tables, Compound conditions, Formats, Sequences and Indexes.(PSLO 3); measured by end of chapter Assessment assignment.
5. The Design of SQL. (PSLO 4); measured by end of chapter Assessment assignment.
6. The Multiuser Environment with password (PSLO 5); measured by end of chapter Assessment assignment.
Core Objectives * Critical Thinking Skills: Students will engage in creative and/or innovative thinking, and/or inquiry, analysis, evaluation, synthesis of information, organizing concepts and constructing solutions.

* Empirical and Quantitative Skills: Students will demonstrate applications of scientific and mathematical concepts.

* Teamwork: Students will demonstrate the ability to work effectively with others to support a shared purpose or goal and consider different points of view.
Program Student Learning Outcomes Alpha. Demonstrates comprehension of content-area reading material

1. Utilize basic software development terminology and concepts.
2. Apply a software-development process to develop and troubleshoot a software product.
3. Create computer graphics for inclusion into a software product.
4. Explain ethical practices within the computer field.
5. Identify procedures for security risk management in the computer field.
Textbooks Textbook Purchasing Statement: A student attending Lamar State College Port Arthur is not under any obligation to purchase a textbook from the college-affiliated bookstore. The same textbook may also be available from an independent retailer, including an online retailer.

SQL Fundamentals (3rd Edition), by John J. Patrick.
ISBN-13: 978-0137126026

You will also need a flash drive or a cloud account to save work onto.
Lecture Topics
Outline
1. Storing information in tables.
2. Getting information from a table.
3.Compound conditions.
4. More about Tables.
5.The Data Dictionary and Other Oracle Topics.
6.Creating your own tables.
7. Inner Joins.
8. Outer Joins.
9. Union and Union All.
10. Cross Joins, Self Joins and Cross-tab Queries.
Major Assignments
Schedule

Week 1: Syllabus review, pre-test, Blackboard and Self Service Banner.

For each week there will be an assignment and a possible quiz.

Basic concepts of the Access 2016.
Week 2: Storing information in tables; Chapter (1).
Week 3: Getting information from a table; Chapter (2).
Week 4: Compound conditions in the Where clause; Chapter (3).
Saving your results; Chapter (4).
Week 5: The Data Dictionary and Other Oracle Topics; Chapter (5).
Week 6: Creating your own tables; Chapter (6).
Week 7: Lab Work & Midterm project.
Week 8: Review for Test & Midterm Exam
Week 9: March 15 - 19 Spring Break
Week 10: Inner Joins; Chapter (13).
Week 11: Outer Joins; Chapter (14) & lab work.
Week 12: Union and Union All; Chapter (15).
Week 13: Lab Work
Week 14:Cross Joins, Self Joins and Cross-tab Queries; Chapter (16).
Week 15: Lab Work & Final project
Week 16: Course revision and Final Exam.
Schedule is subject to change














Final Exam Date May 10, 2022 - 11:00 AM   Through  May 10, 2022 - 12:30 PM
Grading Scale  90 - 100=A    80 - 89=B    70 - 79=C     60 - 69=D    Below 59 = F
Determination of
Final Grade
Quizzes & Lab Work - 20%,
Project - 40%
Exams - 40%
Course Policies
Instructor Policies I will not discuss your grades over the phone or by e-mail. If you want to discuss your grades, you must come to my office in person.

Homework assignments will be given each week.

LATE WORK is highly discouraged and will incur a 10 point penalty for every day it is late. Due dates are given and enough time is given to complete all work. NO EXCEPTIONS.

If you miss an exam, your lowest test grade will count twice. If you miss more than one exam, those exams will be given a grade of zero. Students must leave the classroom after exam is finished.

There will be a final exam. All students must take the exam on the scheduled date and time, and failure to do so will result in a 0 on the final exam.

Every student MUST have a copy of the required textbooks by the SECOND week of class. The student will still be responsible for any assignments given. Failure to have a text may result in being dropped from the class.

No emailed work is accepted.

Students are responsible for completing all assigned reading and video viewings.

A failure to follow oral and/or written instructions will result in penalties.
Academic dishonesty will result in a zero on any assignment; a second incidence of academic dishonesty will be handled based on campus policies and procedures with the department chair.

Student IDs are required for the first exam. IDs must be visible on your desk before the exam is administered. No ID, No exam.

Software Requirements:
If you are in a course that is using a specific software, you MUST have the software available to you either on your home computer or you must use the open lab provided in the Gates Library.

Reliable Internet access is required for all online courses and many traditional courses.

Computer failure and lack of internet access are not acceptable excuses for missed assignments, projects, quizzes, or exams. DO NOT wait until the last minute to complete class work or exams.

Classroom Etiquette:
The following behaviors will result in the student being asked during class time to cease the action and/or leave the classroom: using cell phones, talking, or keying while the instructor is giving instructions or during class discussions; leaving class early without informing the instructor in advance; surfing the Internet during lecture; and displaying a rude or negative behavior toward the instructor or other students.

No cell phones should be visible or heard during class. Again, you will be asked to leave the room for the remainder of the class. No blue tooth technology or recording of lectures in any format (unless approved by the instructor). No charging of cell phones in the classroom.

E-Mail/Voice Mail Etiquette:
Students must use appropriate e-mail etiquette when corresponding with instructor; for example, complete sentences and a full subject line with your name/course name. Voice mail messages should be clearly spoken identifying students name, course, and any return phone number.
Attendance Policy Poor attendance is a leading reason for termination from a job in all areas of employment. With this factor in mind, the instructor monitors student attendance daily. In addition, attendance on a regular basis is necessary for proper skill development. A tardy is an absence for attendance purposes.

4 absences = one letter grade drop
6 absences = two letter grade drop
8 absences = automatic failure of class

Quizzes may be given at the beginning of the class period. Students coming in to class late will not be allowed to take quizzes already turned in. A grade of zero will be recorded for the quiz.

Assignments are due at the beginning of each class; student assignments coming in late will be assessed a penalty, even if the student arrives to class late and turns in work.

Students are responsible for completing all assigned homework, including reading assignments, by the required due dates and for being prepared for each class meeting. This applies even if you were absent from the previous class meeting.
Academic Honesty Academic honesty is expected from all students, and dishonesty in any form will not be tolerated. Please consult the LSC-PA policies (Section IX, subsection A, in the Faculty Handbook) for consequences of academic dishonesty.
Facility Policies
  1. No food or tobacco products are allowed in the classroom.

  2. Only students enrolled in the course are allowed in the classroom, except by special instructor permission.

  3. Use of electronic devices is prohibited.
Important Information
ADA Considerations The Americans with Disabilities Act (ADA) is a federal anti-discrimination statute that provides comprehensive civil rights for persons with disabilities. Among other things, this legislation requires that all students with disabilities be guaranteed a learning environment that provides for reasonable accommodation of their disabilities. If you believe you have a disability requiring an accommodation, please contact the the Office for Disability Services Coordinator, Room 231, in the Madison Monroe Building. The phone number is (409) 984-6241.
MyLSCPA Be sure to check your campus E-mail and Course Homepage using MyLSCPA campus web portal (My.LamarPA.edu). When you've logged in, click the email icon in the upper right-hand corner to check email, or click on the "My Courses" tab to get to your Course Homepage. Click the link to your course and review the information presented. It is important that you check your email and Course Homepage regularly. You can also access your grades, transcripts, and determine who your academic advisor is by using MyLSCPA.
Other
HB 2504 This syllabus is part of LSC-PA's efforts to comply with Texas House Bill 2504.
Department
Business and Industrial Technology
Chair:Sheila Guillot
E-mail:guillsr@lamarpa.edu
Phone:(409) 984-6381

If you have a grievance, complaint, or concern about this course that has not been resolved through discussion with the Instructor, please consult the Department Chair.